home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
The World of Computer Software
/
The World of Computer Software.iso
/
pbaseiv.zip
/
P4SPR006.TIP
< prev
next >
Wrap
Text File
|
1991-12-16
|
2KB
|
78 lines
Typing `123 filename' at the DOS prompt, where filename is
the name of a spreadsheet file, ought to cause 1-2-3 to
bring up that spreadsheet automatically--but it doesn't. So,
most users are forced to start 1-2-3 and then retrieve their
files with the /FR command.
I use the batch file below, named L123.BAT, to start 1-2-3
and automatically load the file I want to work on. If I type
L123 filename (without the assumed WK3 extension), the file
is loaded at once. If I don't type a file name, I get a
blank worksheet.
This batch file assumes that 1-2-3 is in the C:\SLOTUS
directory and that the data files are in a directory called
C:\SLOTUS\SFILES. You should change the batch file to
reflect your own choice of directories.
Mark Burgess
St. Louis
Editor's note: Mr. Burgess's original batch file was
intended for 1-2-3 Release 3; I've changed it to run with
the more popular 2.x releases. The principle is the same,
only the file extension changes. To use L123.BAT with
Release 3, change every "WK1" to "WK3".
This batch file takes advantage of a very useful (and
surpassingly obscure) feature of 1-2-3--the AUTO123 file. If
there's a worksheet with this name in the default data
directory, it's loaded automatically when 1-2-3 starts. By
simply changing your file's name to AUTO123.WK1 before
loading 1-2-3, and changing it back again after you exit,
the batch file tricks the spreadsheet into loading your
file. You can copy the listing below to a file using the
Alt-F command, then modify it to suit your needs.
Postscript: After this tip was published, a few readers
wrote to tell us that recent versions of 1-2-3 include an
even simpler way to open a spreadsheet at startup. We
haven't verified that it works with every version, but the
command
123 -wFilename
opens "Filename" automatically at startup under Release 2.2
and Release 3.
L123.BAT
---- BEGIN LISTING ----
@echo off
c:
if "%1"=="" goto nofile
cd c:\lotus\files
ren %1.wk1 auto123.wk1
set filename=%1.wk1
cd c:\lotus
123
c:
cd c:\lotus\files
ren auto123.wk1 %filename%
set filename=
goto end
:nofile
cd c:\lotus
123
:end
echo on
---- END LISTING ----
Title: Spread Out Your Spreadsheet Automatically
Category: SPR
Issue date: Nov 1991
Editor: Brett Glass
Supplementary files: NONE